UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '20KM/cEDmOcj+o3IycvbVlp1wklPKkE0CDTZUm5Sgf4='
WHERE
key_id = 'cb9bb71d27aed83966126c44f8132aa88b9a2acd3d849e24d099c5ba3c9df504'
AND (
token = '20KM/cEDmOcj+o3IycvbVlp1wklPKkE0CDTZUm5Sgf4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)