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