UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l9EpVugeNYj2+8cxnQiS65Crd9EY2iLbvs/2LSvsZzI='
WHERE
key_id = 'f398c2d88bc5b94d487d028b081a0edb1eac55f8de01d01a490548127155a542'
AND (
token = 'l9EpVugeNYj2+8cxnQiS65Crd9EY2iLbvs/2LSvsZzI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)