UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0p5EbQEMNwY1wGeGQowVTqvs9bDGrIVP0MiwpUyUJiA='
WHERE
key_id = '3d7518d650cdcc8979f2b4abb2da244143f0765410c35bba0ca111b17f2629f5'
AND (
token = '0p5EbQEMNwY1wGeGQowVTqvs9bDGrIVP0MiwpUyUJiA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)