UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RiXkrFN16ZiaFoer5zyeZPAsX7FmXE6NnjXJovttCQ0='
WHERE
key_id = 'bae249818eda9dc57491312c24e7510e793556f329baf1a3fe0e6be82f0b001d'
AND (
token = 'RiXkrFN16ZiaFoer5zyeZPAsX7FmXE6NnjXJovttCQ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)