UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9KxPiOOFWtbClGNdZKH2F0YOIM2CEZdIzskE1CRp/pw='
WHERE
key_id = 'be322e95cc6719963c821dafe71dce256bbdfb2919c938634f940baaf9ca2935'
AND (
token = '9KxPiOOFWtbClGNdZKH2F0YOIM2CEZdIzskE1CRp/pw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)