UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RUW46P219ySuYdvxeuko1h/yUJP7/yqXe47wbdVsU44='
WHERE
key_id = 'ee2686b9581c30c2a2d182186f16f4dcee168ca69e51ba5cfa2af53a0c60a31f'
AND (
token = 'RUW46P219ySuYdvxeuko1h/yUJP7/yqXe47wbdVsU44='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)