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