UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D3Lb79c7XBHYQiSCv62y3O2qXjjlCh+jrCRRglIh2Bs='
WHERE
key_id = 'b1d032bfc189ab15d4772f3e632b5e9bdcc0ff1a2d4c8435a371e6d02f7b50f4'
AND (
token = 'D3Lb79c7XBHYQiSCv62y3O2qXjjlCh+jrCRRglIh2Bs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)