UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lCfugtIQkb7mkiHtwHjmlF1NW6TEtiWDST/7+5V3yHA='
WHERE
key_id = '669977580e25848990b7a4b270532c9918cc6c7cb0458e59f6e90d38f3616227'
AND (
token = 'lCfugtIQkb7mkiHtwHjmlF1NW6TEtiWDST/7+5V3yHA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)