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