UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gsCghY1M0OYCKI3WVb8fgwjQhEXxF6hex/ot9f6lI9M='
WHERE
key_id = '3a41179b9e7d83cd33e8577dd28857c949e89ea3b039f904a85e1f01a1ccc001'
AND (
token = 'gsCghY1M0OYCKI3WVb8fgwjQhEXxF6hex/ot9f6lI9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)