UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iaAHbHNByWhSSImhYSFsD0qYAno+7f+i6WezAJqBatU='
WHERE
key_id = 'e49babbf7b487ce02a5636a2aa6158b254cc452c8416805cb1b42e82b4f7f1b9'
AND (
token = 'iaAHbHNByWhSSImhYSFsD0qYAno+7f+i6WezAJqBatU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)