UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2lfOB7jriHDYA34qNKujD0ChGDxuf2te1WHZLscCpYI='
WHERE
key_id = '292720b1c78a3e0a61f9bb67d0f654f9ee4202483f85d404b0602a11ab63816b'
AND (
token = '2lfOB7jriHDYA34qNKujD0ChGDxuf2te1WHZLscCpYI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)