UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mjJosw1/xIvtvc73mTjCdli4TE9A4VolZdnohWBZZ4Y='
WHERE
key_id = 'd528595409df5e5cf7da7611da3631e24011f9005e848691920c3065fe221455'
AND (
token = 'mjJosw1/xIvtvc73mTjCdli4TE9A4VolZdnohWBZZ4Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)