UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lj78vYZoJzO750tiC/6CFsckfI2o+BxfB04aiVxIhdM='
WHERE
key_id = '27b49ef2e1722c334b216f91adb7f7d9a8ce0deedb8ce4af2a36fee34a390ab2'
AND (
token = 'lj78vYZoJzO750tiC/6CFsckfI2o+BxfB04aiVxIhdM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)