UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oVfUbHEHwe80j6sqKs6vp5nuBD3iTX5DLgW+yWeeqsk='
WHERE
key_id = 'a4c4b62ace8b73f1fa27a1beba6d4b84c9f016a69b778233b91291e511d1bd67'
AND (
token = 'oVfUbHEHwe80j6sqKs6vp5nuBD3iTX5DLgW+yWeeqsk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)