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