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