UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DIGL/ji46WkvAZ3r+UZkggb/B0chC7hDkbpC4wVHZ6w='
WHERE
key_id = 'b11aaa8ff1ad19b70d8c47374397f139c09737d464757a9a280ef054ee11e035'
AND (
token = 'DIGL/ji46WkvAZ3r+UZkggb/B0chC7hDkbpC4wVHZ6w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)