UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/Fx17cu7NXaEDOx/BtjWJAoFySAnckc1NLeBNnO/XBM='
WHERE
key_id = 'b8e448f0163336af54d382f17847e8c68f3c647ebea2d350de4d580bbc13b8dd'
AND (
token = '/Fx17cu7NXaEDOx/BtjWJAoFySAnckc1NLeBNnO/XBM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)