UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z9PAu3faaeY9J9fx1dtvJPZ9C314vaSiucNZl56Y6lA='
WHERE
key_id = '5a61f902b2db607464e0c703f781ed16d36b33f83937d8e27daaaacd9119df96'
AND (
token = 'z9PAu3faaeY9J9fx1dtvJPZ9C314vaSiucNZl56Y6lA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)