UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pzgkOSbWtcZn1hWjNJw+Bn3PbGIF4th3Rk/UUwrwYJc='
WHERE
key_id = 'e6e4562e51d9c4cb2409aa3a894515af64cc34e41b2b417df7423033b7287b12'
AND (
token = 'pzgkOSbWtcZn1hWjNJw+Bn3PbGIF4th3Rk/UUwrwYJc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)