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