UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qNR/D3qKrbRH45ZgK2g0A9yZF9ZpAZp7YdT4yAJbCXo='
WHERE
key_id = '553c67788ae72622e3736a91d398482b49073ad986734109770c4b2a1b74d17b'
AND (
token = 'qNR/D3qKrbRH45ZgK2g0A9yZF9ZpAZp7YdT4yAJbCXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)