UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bS/EFiNDZ901I1QlpzteAa/LPJYDbCzfTEZKz34c6QU='
WHERE
key_id = '0f71b7acf06d119bf0d8627488f5717683ca19c3730442099cdced0d3726eb70'
AND (
token = 'bS/EFiNDZ901I1QlpzteAa/LPJYDbCzfTEZKz34c6QU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)