UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4pMxiDvO6pcOC4ypPALBn5I6dzUS2hfv7nU9II30dD0='
WHERE
key_id = '25b5028a7a8c6a63ba7a54cfc99103e4ba308da70fe33f2c03b86b01e6418047'
AND (
token = '4pMxiDvO6pcOC4ypPALBn5I6dzUS2hfv7nU9II30dD0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)