UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zNFwn7pACF0kDi7+724KRBeCyBSo8fq1u2BWd8lpBIc='
WHERE
key_id = '9410acfd67ecc0448a30190f41a2c349b56e292bf5fa8eba3f34611eae18169f'
AND (
token = 'zNFwn7pACF0kDi7+724KRBeCyBSo8fq1u2BWd8lpBIc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)