UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vRDah2R9Ebh3EJ4GXEqqzYpng3yKoU6ALfgCX+hzDCA='
WHERE
key_id = '9173161eb7b1d2694ecfbc9693e688f4f88da793924c0d489c174c314f7b40f5'
AND (
token = 'vRDah2R9Ebh3EJ4GXEqqzYpng3yKoU6ALfgCX+hzDCA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)