UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4/q7fNQf+1s/iHjuJtCAbtRFgClcK2yVbcd/nKDou+E='
WHERE
key_id = '74bf725aaa1ccf85ce59b26710cf787c12b5ec60442beb99bc2b71dad16edfe7'
AND (
token = '4/q7fNQf+1s/iHjuJtCAbtRFgClcK2yVbcd/nKDou+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)