UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K3QXEfOAK/wGPHRXx26y9pILVjBmQoVjYD/00sIBuRk='
WHERE
key_id = 'b25a4907cb1ce029ebe91f5db3e9eea4b06734178d49ce540a4cfd01a077b807'
AND (
token = 'K3QXEfOAK/wGPHRXx26y9pILVjBmQoVjYD/00sIBuRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)